Exploring EVENTS¶
Experiments¶
- Visualising Events Dataframe
- Exploring Tags Events
- Calculating Events Description Similarity
- Calculating Events Description Topic Modelling
- Exploring the Schedules of Events
- 5.1 Getting the Frequency of Starting Dates of Events Schedules
- 5.2 Getting the Frequency of End Dates of Events Schedules
- Exploring the Schedules of Events
- Exploring the Performances Tickets of Events Schedules
- 6.1 Getting the Frequency of Price Tickets
- 6.2 Getting the frequency of type (Standard, Children) tickets
- 6.3 Exploring Performances Places -
- 6.3.1 Frequency of Performances per town
- 6.3.2 Frequency of Type tickets per town
- 6.3.3 Frequency of Price tickets type per town
- 6.3.4 Frequency of Max_Price tickets per town
- 6.3.4.1 Frequency of Free tickets per town
- 6.3.4.2 Frequency of No Free tickets per town
- 6.4 Selecting Scottish Cities: Edinburgh, Glasgow, Dundee, Perth, Inverness, Aberdeen, St Andrews
- 6.4.1 Frequency of Price Tickets per Scottish City
- 6.4.2 Frequency of Type Tickets per Scottish City
- 6.4.3 Frequency of Schedules Dates per Event and per Scottish City
- 6.4.4.Grouping Schedules per Event and Scottish City
- 6.4.5 Exploring Tags per Schedule and Scottish Cities
- 6.4.5.1 Exploring the Frequency of schedules tags for Edinburgh
- 6.4.5.2 Exploring the Frequency of schedules tags for Glasgow
- 6.4.6 Histograms of starting/end schedules dates for Edinburgh
- 6.4.7 Working with Schedule tags, Scottish cities, Starting/End Time
- 6.4.7.1 Frequency of schedules Starting Date in Scottish City
- 6.4.7.2 Frequency of schedules Ending Date in Scottish City
- 6.4.7.3 Scheduled tags and Starting Dates in Scottish City
- 6.4.7.4 Scheduled tags and Starting Dates in Scottish City
- Exploring the Performances Tickets of Events Schedules
0. Importing libraries and loading the json file with 5000 events to a dataframe¶
In [1]:
import json
import pandas as pd
import plotly.express as px
import os
from bertopic import BERTopic
from sentence_transformers import SentenceTransformer
from sklearn.metrics.pairwise import cosine_similarity
import pickle
import plotly.graph_objects as go
import numpy as np
from gensim.parsing.preprocessing import remove_stopwords
import re
In [2]:
with open('events.json', 'r') as f:
data = json.load(f)
df = pd.DataFrame(data)
1. Visualizing the events dataframe¶
In [3]:
df
Out[3]:
In [4]:
## selecting some columns
Experiment 2: Exploring Tags Events¶
We are going to separete the elements stored in each tag list into new rows.
In [5]:
df["tags"][0:5]
Out[5]:
In [6]:
df_tags=df.explode('tags')
In [7]:
df_tags
Out[7]:
In [8]:
g_tags=df_tags.groupby(['tags']).size().reset_index()
g_tags=g_tags.rename(columns={0: "number_of_times"}).sort_values(by=['number_of_times'], ascending=False)
g_tags
Out[8]:
In [9]:
fig = px.line(g_tags, x="tags", y="number_of_times", title='Number of times that each tag appears')
fig.show()
Experiment 3: Description Similarity¶
Exploding the column description¶
Given a description cell, with a list of descriptions, we will create new row per element in that list.
In [10]:
df["descriptions"][0:5]
Out[10]:
In [11]:
df_descriptions=df.explode('descriptions')
In [12]:
df_d=pd.concat([df_descriptions.drop(['descriptions'], axis=1), df_descriptions['descriptions'].apply(pd.Series)], axis=1)
In [13]:
df_desc=df_d[["event_id", "description"]]
In [14]:
df_desc
Out[14]:
Finding similar descriptions events - Deep Learning - Transformers¶
In [15]:
# remving the rows which description is empty
df_desc1=df_desc.dropna(subset=['description']).reset_index()
In [16]:
df_desc1[0:5]
Out[16]:
In [17]:
# total number of rows with descriptions
df_desc1.shape[0]
Out[17]:
In [18]:
#selecting the description colum
documents=df_desc1["description"].values
In [19]:
#d=documents[0:100]
#d=documents[:]
In [20]:
def clean_documents(text):
text = re.sub(r'\S*@\S*\s?', '', text, flags=re.MULTILINE) # remove email
text = re.sub(r'http\S+', '', text, flags=re.MULTILINE) # remove web addresses
text = re.sub("\'", "", text) # remove single quotes
text = remove_stopwords(text)
return text
We are going to save clean documents in d¶
In [21]:
d=[]
for text in documents:
d.append(clean_documents(text))
In [22]:
# Using all-MiniLM-L6-v2 Transformer
model = SentenceTransformer('all-MiniLM-L6-v2')
In [23]:
#Training our text_embeddings - using the descriptions available & all-MiniLM-L6-v2 Transformer
text_embeddings = model.encode(d, batch_size = 8, show_progress_bar = True)
In [24]:
np.shape(text_embeddings)
Out[24]:
In [25]:
### A small example how to get an embedding vector from a description
In [26]:
first_description=df_desc1["description"].iloc[0]
first_description
first_description_embedding= model.encode(first_description, batch_size = 8, show_progress_bar = True)
Finding the similarity between documents¶
In [27]:
similarity_def=cosine_similarity(
[first_description_embedding],
text_embeddings)
In [28]:
similarities = cosine_similarity(text_embeddings)
print('pairwise dense output:\n {}\n'.format(similarities))
In [29]:
similarities_sorted = similarities.argsort()
similarities_sorted
Out[29]:
In [30]:
id_1 = []
id_2 = []
score = []
for index,array in enumerate(similarities_sorted):
p=len(array)
id_1.append(index)
id_2.append(array[-2])
score.append(similarities[index][array[-2]])
index_df = pd.DataFrame({'id_1' : id_1,
'id_2' : id_2,
'score' : score})
print(p)
In [31]:
index_df
Out[31]:
Exploring documents 3 and 4085 - similarity score: 0.77¶
In [32]:
documents[3]
Out[32]:
In [34]:
documents[4085]
Out[34]:
Finding the first 10 similar definitions given the document 3¶
In [35]:
## Lets take the document 3
doc_index =3
documents[3]
Out[35]:
In [36]:
results={}
for i in range(-2, -12, -1):
similar_index=similarities_sorted[doc_index][i]
rank=similarities[doc_index][similar_index]
results[similar_index]=[rank]
In [37]:
results
Out[37]:
Experiment 4: Description Topic Modelling - Deep Learning - BERTopic¶
Lets find the topic modelling of our descriptions We are going to use the text_embeddings calculated in the previous phase.
In [38]:
len(documents)
Out[38]:
In [39]:
topic_model = BERTopic(min_topic_size=20).fit(d, text_embeddings)
In [40]:
topics, probs = topic_model.transform(d, text_embeddings)
Visualizing our topics¶
In [41]:
topic_model.visualize_topics()
In [42]:
#### Visualzing the first 5 keywords of our first 5 topics
In [43]:
topic_model.visualize_barchart()
Visualizing the similarity between topics¶
In [44]:
topic_model.visualize_heatmap()
Getting the frequency of each topic.¶
We should always ignore the first -1 topic.
In [45]:
#Lets see the frequency of the first 10 topics
topic_model.get_topic_freq()[0:10]
Out[45]:
In [46]:
print("Number of topics found %s" %len(topic_model.get_topic_freq()))
Visualizing the keywords of our topics.¶
In [47]:
#topic_model.get_topics()
In [48]:
document_0_topic=topics[0]
print("The topic of the document 0 is %s " %document_0_topic)
In [49]:
topic_model.get_topic(0)
Out[49]:
In [50]:
df_desc1["description"].iloc[0]
Out[50]:
Experiment 5: Exploring the Schedules of Events¶
- 1 Event can have 1 to N Schedules.
- 1 Schedule is in 1 Place
- 1 Schedule can have 1 to N Performances
- 1 Peformance can have 1 to N Tickets
- 1 Ticket has a max_price, min_price, currency.
Lets starting exploding the schedules column
In [51]:
df["schedules"]
Out[51]:
In [52]:
df_schedules=df
df_schedules.rename(columns={'tags':'event_tags'}, inplace=True)
df_schedules.rename(columns={'name':'event_name'}, inplace=True)
df_schedules.rename(columns={'links':'event_links'}, inplace=True)
df_schedules=df.explode('schedules')
#df_schedules
df_s=pd.concat([df_schedules.drop(['schedules'], axis=1), df_schedules['schedules'].apply(pd.Series)], axis=1)
In [53]:
df_s.iloc[0]
Out[53]:
Getting the Frequency of Starting Dates of Events Schedules¶
In [54]:
df_start=df_s.groupby([pd.to_datetime(df_s['start_ts'])]).size().reset_index()
df_start=df_start.rename(columns={0: "number_of_times"})
df_start=df_start.sort_values(by=['number_of_times'], ascending=False)
df_start.reset_index()
Out[54]:
This means that we have 426 events' schedules starting at 2022-01-27 19:00:00+00:00
In [55]:
#### Visualizing the previous Start_Ts Schedules Events Freq.
In [56]:
fig = px.histogram(df_start, x='start_ts', y="number_of_times", title="Frequency of Starts Dates Schedules")
fig.show()
Getting the Frequency of End Dates of Events Schedules¶
In [57]:
df_end=df_s.groupby([pd.to_datetime(df_s['end_ts'])]).size().reset_index()
df_end=df_end.rename(columns={0: "number_of_times"})
df_end=df_end.sort_values(by=['number_of_times'], ascending=False)
df_end.reset_index()
fig = px.histogram(df_end, x='end_ts', y="number_of_times", title="Frequency of End Dates Schedules")
fig.show()
Experiment 6: Exploring the Performances Tickets of Events Schedules¶
- 1 Event can have 1 to N Schedules.
- 1 Schedule is in 1 Place
- 1 Schedule can have 1 to N Performances
- 1 Peformance can have 1 to N Tickets
- 1 Ticket has a max_price, min_price, currency.
Lets starting exploding the performance column. We can not explode the performance column, if we hadnt have exploded the schedules column before. For that reason, we are using df_s dataframe, which has already exploded the schedules column.
In [58]:
df_s
Out[58]:
In [61]:
df_p= df_s.explode("performances")
df_p=pd.concat([df_p.drop(['performances'], axis=1), df_p['performances'].apply(pd.Series)], axis=1)
In [62]:
df_p[0:2]
Out[62]:
Exploring tickets¶
Now we have to explode the tickets column. We are going to remove the rows which tickets information is empty.
In [63]:
df_p=df_p.dropna(subset=['tickets'])
Since we dont need all the columns, we have selects a few of them.
In [91]:
df_t=df_p[["event_id", "event_name", "descriptions", "event_tags", "tickets", "place_id", "place", "start_ts", "end_ts"]]
In [92]:
df_t[0:5]
Out[92]:
In [93]:
df_t1=df_t.explode("tickets")
Now we are going to transform the max, and min prices of tickets to numeric values.
In [94]:
df_tickets=pd.concat([df_t1.drop(['tickets'], axis=1), df_t1['tickets'].apply(pd.Series)], axis=1)
df_tickets['min_price'] = pd.to_numeric(df_tickets['min_price'])
df_tickets['max_price'] = pd.to_numeric(df_tickets['max_price'])
df_tickets['min_price']= df_tickets['min_price'].fillna(0)
df_tickets['max_price']= df_tickets['max_price'].fillna(0)
In [95]:
df_tickets[0:5]
Out[95]:
Experiment 6.1: Getting the Frequency of Price Tickets¶
We are working just with max_price.
In [96]:
g_maxp=df_tickets.groupby(['max_price']).size().reset_index()
g_maxp=g_maxp.rename(columns={0: "number_of_times"})
#g_maxp=g_maxp.sort_values(by=['number_of_times'], ascending=False)
free_tickets=g_maxp[0:1]
## Removing FREE TICKETS
g_maxp=g_maxp.drop([0])
###
g_maxp[:]
Out[96]:
In [97]:
fig = px.line(g_maxp, x="max_price", y="number_of_times", title='Frequency of price tickets')
fig.show()
In [98]:
print("The number of free tickets is: %s" %free_tickets["number_of_times"].values[0])
Experiment 6.2: Getting the frequency of type (Standard, Children) tickets¶
In [99]:
tickets_type=df_tickets.groupby(['type']).size().reset_index()
tickets_type=tickets_type.rename(columns={0: "number_of_times"}).sort_values(by=['number_of_times'], ascending=False)
tickets_type
Out[99]:
In [100]:
px.histogram(tickets_type, x="type", y="number_of_times", histfunc="sum", color="type", title='Frequency of type tickets')
6.3 Exploring Performances Places¶
In [102]:
df_t1=df_t.explode("tickets")
df_tickets=pd.concat([df_t1.drop(['tickets'], axis=1), df_t1['tickets'].apply(pd.Series)], axis=1)
df_tickets['min_price'] = pd.to_numeric(df_tickets['min_price'])
df_tickets['max_price'] = pd.to_numeric(df_tickets['max_price'])
df_tickets['min_price']= df_tickets['min_price'].fillna(0)
df_tickets['max_price']= df_tickets['max_price'].fillna(0)
In [77]:
df_tickets[0:5]
Out[77]:
6.3.1 Frequency of Performances per Town¶
In [103]:
df_place=pd.concat([df_tickets.drop(['place'], axis=1), df_tickets['place'].apply(pd.Series)], axis=1)
In [104]:
df_town=df_place.dropna(subset=['town'])
town=df_town.groupby(['town']).size().reset_index()
town=town.rename(columns={0: "number_of_times"})
town=town.drop([0])
In [105]:
town=town.sort_values(by=['number_of_times'], ascending=False)
town
Out[105]:
In [106]:
px.scatter(town, x="town",y='number_of_times', color='number_of_times', size="number_of_times", size_max=60, title="Frequency of Performances per Town")
6.3.2 Frequency of Type tickets per town¶
In [107]:
town_type=df_town.groupby(['town', 'type']).size().reset_index()
town_type=town_type.rename(columns={0: "number_of_times"})
town_type=town_type[town_type["town"]!=""]
In [108]:
town_type=town_type.sort_values(by=['number_of_times'], ascending=False)
town_type
Out[108]:
In [109]:
fig = px.scatter(town_type, x='town', y='type', color='number_of_times', title="Frequency of type tickets per town")
fig.show()
In [110]:
px.scatter(town_type, x="town",y='type', color='number_of_times', size="number_of_times", size_max=60, title="Frequency of performances type tickets per town")
6.3.3. Frequency of Max_Price tickets per towns¶
In [111]:
a=df_town[["town", "max_price"]]
a=a[a["town"]!=""]
town_price=a.groupby(['town', 'max_price']).size().reset_index()
town_price=town_price.rename(columns={0: "number_of_times"})
town_price=town_price.sort_values(by=['number_of_times'], ascending=False)
town_price
Out[111]:
6.3.3.1. Frequency of free tickets per town¶
In [112]:
free_town_price=town_price[town_price["max_price"]== 0.0]
free_town_price
Out[112]:
In [113]:
fig = px.bar(free_town_price, x='town', y='number_of_times', color='number_of_times', barmode='group', title="Frequency of Free Tickets per Town")
fig.show()
6.3.3.1. Frequency of No free tickets per town¶
In [114]:
town_price=town_price[town_price["max_price"]!= 0.0]
town_price
Out[114]:
In [115]:
fig = px.bar(town_price, x='town', y='max_price', color='number_of_times', barmode='group', title="Frequency of Price Tickets per Town")
fig.show()
In [116]:
town_price.groupby(["town"]).sum().sort_values(by=['max_price'], ascending=False)
Out[116]:
6.4 Selecting Scottish Cities: Edinburgh, Glasgow, Dundee, Perth, Inverness, Aberdeen, St Andrews¶
6.4.1 Frequency of Price Tickets per Scottish City¶
In [117]:
scot_towns_price=town_price[town_price['town'].isin(["Edinburgh", "Glasgow", "Perth", "Inverness", "Dundee", "St Andrews", "Aberdeen"])]
In [118]:
scot_towns_price[0:10]
Out[118]:
In [119]:
fig = px.bar(scot_towns_price, x='town', y='max_price', color='number_of_times', barmode='group', title="Frequency of Price Tickets per Scottish City")
fig.show()
In [120]:
scot_towns_price.groupby(["town"]).sum().sort_values(by=['max_price'], ascending=False)
Out[120]:
6.4.2 Frequency of Type Tickets per Scottish City¶
In [121]:
scot_towns_type=town_type[town_type['town'].isin(["Edinburgh", "Glasgow", "Perth", "Inverness", "Dundee", "St Andrews", "Aberdeen"])]
In [122]:
scot_towns_type[0:10]
Out[122]:
In [123]:
fig = px.bar(scot_towns_type, x='town', y='number_of_times', color='type', barmode='group', title="Frequency of Type Tickets per Scottish City")
fig.show()
In [124]:
scot_towns_type.groupby(["town"]).sum()
Out[124]:
In [125]:
df_place.loc[0]
Out[125]:
6.4.3.3 Frequency of Schedules Dates per Event and per Scottish City¶
In [126]:
df_place2=df_place.dropna(subset=['town'])
df_place2
df_scott=df_place2[df_place2['town'].isin(["Edinburgh", "Glasgow", "Perth", "Inverness", "Dundee", "St Andrews", "Aberdeen"])]
df_scott=df_scott[["event_id", "event_name", "event_tags", "town", "start_ts", "end_ts"]]
df_scott[0:3]
Out[126]:
Note: An event can have several schedules. And a schedule has an starting and end date. Therefore, an event can have several starting and end dates.
In [127]:
fig = px.scatter(df_scott, x='start_ts', y="event_name", title="Frequency of starting date per event in Scottish cities")
fig.show()
In [128]:
fig = px.scatter(df_scott, x='end_ts', y="event_name", title="Frequency of ending date per event in Scottish cities")
fig.show()
6.4.4 Grouping Schedules per Event and Scottish City¶
In [129]:
scott_schedule=df_scott.groupby(['event_name', 'town']).size().reset_index()
scott_schedule=scott_schedule.rename(columns={0: "number_of_times"})
scott_schedule=scott_schedule.sort_values(by=['number_of_times'], ascending=False)
scott_schedule
Out[129]:
This means that the "Mercat Tours: Historic Underground" event has been scheduled 2944 times in Edinburgh
In [130]:
t=scott_schedule.groupby(["event_name"]).sum().sort_values(by=['number_of_times'], ascending=False)
t
Out[130]:
This means that the "St Andrews Ghost Tours" event has been scheduled 1932 times
In [131]:
fig = px.bar(t, title="Frequency of Schedules per event")
fig.show()
6.4.5 Exploring Tags per Schedule and Scottish Cities.¶
In [132]:
a=df_scott.reset_index(drop=True)
tags_town=a[["event_tags", "town"]]
tags_town=tags_town.explode("event_tags")
tags_town
Out[132]:
In [133]:
scott_tag=tags_town.groupby(['town', 'event_tags']).size().reset_index()
scott_tag=scott_tag.rename(columns={0: "number_of_times"})
scott_tag=scott_tag.sort_values(by=['number_of_times'], ascending=False)
scott_tag
Out[133]:
This means that we have 52865 schedules tagged as Comedy in Edinburgh
In [134]:
fig=px.histogram(scott_tag, x="town", y="number_of_times", histfunc="sum", color="event_tags", title='Frequency of tags in Scottish Cities')
fig.update_layout(legend_traceorder="reversed")
fig.show()
In [135]:
t=scott_tag.groupby(["event_tags"]).sum().sort_values(by=['number_of_times'], ascending=False)
t
Out[135]:
This means that we have 52894 schedules tagged as Comedy in a Scottish city
6.4.5.1 Exploring the Frequency of schedules tags for Edinburgh¶
In [136]:
edi_scott_tag=scott_tag[scott_tag['town'].isin(["Edinburgh"])]
edi_scott_tag
Out[136]:
In [137]:
edi_scott_tag.groupby(["event_tags"]).sum().sort_values(by=['number_of_times'], ascending=False)
Out[137]:
In [138]:
fig = px.bar(edi_scott_tag, x='town', y='number_of_times', color='event_tags', barmode='group', title="Frequency of schedules tags for Edinburgh")
fig.show()
6.4.6 Histograms of starting/end schedules dates for Edinburgh¶
In [139]:
scott_start=df_scott.groupby([pd.to_datetime(df_scott['start_ts']), "town"]).size().reset_index()
scott_start=scott_start.rename(columns={0: "number_of_times"})
scott_start=scott_start.sort_values(by=['number_of_times'], ascending=False)
scott_start.reset_index()
Out[139]:
In [140]:
ed_scott_start=scott_start[scott_start['town'].isin(["Edinburgh"])].reset_index()
ed_scott_start.groupby(["start_ts"]).sum().sort_values(by=['number_of_times'], ascending=False)
#fig = px.bar(ed_scott_start, x='town', y='number_of_times', color='start_ts', barmode='group', title="Frequency of starting date schedules for Edinburgh")
#fig.show()
Out[140]:
In [141]:
scott_end=df_scott.groupby([pd.to_datetime(df_scott['end_ts']), "town"]).size().reset_index()
scott_end=scott_end.rename(columns={0: "number_of_times"})
scott_end=scott_end.sort_values(by=['number_of_times'], ascending=False)
scott_end.reset_index()
ed_scott_end=scott_end[scott_end['town'].isin(["Edinburgh"])].reset_index()
ed_scott_end.groupby(["end_ts"]).sum().sort_values(by=['number_of_times'], ascending=False)
#fig = px.bar(ed_scott_end, x='town', y='number_of_times', color='end_ts', barmode='group', title="Frequency of ending date schedules for Edinburgh")
#fig.show()
Out[141]:
In [142]:
fig = px.histogram(ed_scott_start, x='start_ts', y="number_of_times", title="Histogram of Schedules Starting Dates for Edinburgh")
fig.show()
In [143]:
fig = px.histogram(scott_start, x='start_ts', y="number_of_times", title="Histogram of Schedules Starting Dates for Scottish Cities")
fig.show()
In [144]:
fig = px.histogram(scott_end, x='end_ts', y="number_of_times", title="Histogram of Schedules Ending Dates for Scottish Cities")
fig.show()
In [145]:
fig = px.histogram(scott_end, x="end_ts", y="number_of_times", histfunc="sum", title="Histogram on Date Axes")
fig.update_traces(xbins_size="M1")
fig.update_xaxes(showgrid=True, ticklabelmode="period", dtick="M1", tickformat="%b\n%Y")
fig.update_layout(bargap=0.1)
fig.add_trace(go.Scatter(mode="markers", x=scott_end["end_ts"], y=scott_end["number_of_times"], name="daily"))
fig.show()
6.4.7 Working with Schedule tags, Scottish cities, Starting/End Time¶
In [146]:
b=df_scott.reset_index(drop=True)
tag_town_time=b[["event_tags", "town", "start_ts", "end_ts"]]
tag_town_time=tag_town_time.explode("event_tags")
tag_town_time
Out[146]:
In [147]:
scott_tag_end=tag_town_time.groupby([pd.to_datetime(tag_town_time['end_ts']), "event_tags"]).size().reset_index()
scott_tag_end=scott_tag_end.rename(columns={0: "number_of_times"})
scott_tag_end=scott_tag_end.sort_values(by=['number_of_times'], ascending=False)
scott_tag_start=tag_town_time.groupby([pd.to_datetime(tag_town_time['start_ts']), "event_tags"]).size().reset_index()
scott_tag_start=scott_tag_start.rename(columns={0: "number_of_times"})
scott_tag_start=scott_tag_start.sort_values(by=['number_of_times'], ascending=False)
In [148]:
scott_tag_start
Out[148]:
6.4.7.1 Frequency of schedules Starting Date in Scottish City¶
In [149]:
#fig = px.bar(scott_tag_start, x='event_tags', y='start_ts', color='number_of_times', barmode='group', title="Frequency of schedules tags per Scottish City")
#fig.show()
fig = px.scatter(scott_tag_start, x='start_ts', y='number_of_times', title="Frequency of schedules Starting Date in Scottish City.")
fig.show()
6.4.7.2 Frequency of schedules Ending Date in Scottish City¶
In [150]:
fig = px.scatter(scott_tag_end, x='end_ts', y='number_of_times', title="Frequency of schedules Ending Date in Scottish City.")
fig.show()
6.4.7.3 Scheduled tags and Starting Dates in Scottish City¶
In [151]:
fig = px.scatter(scott_tag_start, x='start_ts', y='event_tags', title="Scheduled Tags and Starting Dates in Scottish City.")
fig.show()
6.4.7.3 Scheduled Tags and Ending Dates in Scottish City¶
In [152]:
fig = px.scatter(scott_tag_end, x='end_ts', y='event_tags', title="Scheduled Tags and Ending Dates in Scottish City.")
fig.show()